package com.fowo.api.model.quality;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import javax.validation.constraints.*;
import lombok.Data;

/** 质检单 导入导出辅助模型 */
@Data
public class QualityCheckStorageExcelPo {

  @Size(max = 50, message = "质检单号长度不能超过20")
  @ExcelProperty(value = "质检单号")
  private String qcSn;

  @ExcelProperty(value = "商品id")
  private Long productId;

  @Size(max = 50, message = "商品图片长度不能超过20")
  @ExcelProperty(value = "商品图片")
  private String productImg;

  @Size(max = 50, message = "商品名长度不能超过20")
  @ExcelProperty(value = "商品名")
  private String productName;

  @Size(max = 50, message = "sku长度不能超过20")
  @ExcelProperty(value = "sku")
  private String sku;

  @Size(max = 50, message = "商品标签长度不能超过20")
  @ExcelProperty(value = "商品标签")
  private String productLabel;

  @ExcelProperty(value = "店铺id")
  private Long shopId;

  @Size(max = 50, message = "店铺名长度不能超过20")
  @ExcelProperty(value = "店铺名")
  private String shopName;

  @Size(max = 50, message = "fnsku长度不能超过20")
  @ExcelProperty(value = "fnsku")
  private String fnsku;

  @Size(max = 50, message = "采购单号长度不能超过20")
  @ExcelProperty(value = "采购单号")
  private String purchaseCode;

  @ExcelProperty(value = "采购员id")
  private Long buyerId;

  @Size(max = 50, message = "采购员长度不能超过20")
  @ExcelProperty(value = "采购员")
  private String buyerName;

  @Size(max = 50, message = "收货单号长度不能超过20")
  @ExcelProperty(value = "收货单号")
  private String deliveryOrderSn;

  @ExcelProperty(value = "收货人id")
  private Long receiveId;

  @Size(max = 50, message = "收货人长度不能超过20")
  @ExcelProperty(value = "收货人")
  private String receiveName;

  @ExcelProperty(value = "仓库id")
  private Long warehouseId;

  @Size(max = 50, message = "仓库长度不能超过20")
  @ExcelProperty(value = "仓库")
  private String warehouseName;

  @ExcelProperty(value = "供应商id")
  private Long supplierId;

  @Size(max = 50, message = "供应商长度不能超过20")
  @ExcelProperty(value = "供应商")
  private String supplierName;

  @DateTimeFormat("yyyy年MM月dd日HH:mm:ss")
  @ExcelProperty(value = "到货时间")
  private java.util.Date receiveTime;

  @ExcelProperty(value = "质检量")
  private Integer productReceiveNum;

  @Size(max = 50, message = "质检方式长度不能超过20")
  @ExcelProperty(value = "质检方式")
  private String qcMethodType;

  @Size(max = 50, message = "质检状态长度不能超过20")
  @ExcelProperty(value = "质检状态")
  private String qcStatus;

  @ExcelProperty(value = "良品量")
  private Integer productGoodNum;

  @ExcelProperty(value = "次品量")
  private Integer productBadNum;

  @ExcelProperty(value = "质检员id")
  private Long qcUserId;

  @Size(max = 50, message = "质检员长度不能超过20")
  @ExcelProperty(value = "质检员")
  private String qcName;

  @DateTimeFormat("yyyy年MM月dd日HH:mm:ss")
  @ExcelProperty(value = "质检时间")
  private java.util.Date qcTime;

  @ExcelProperty(value = "抽检量")
  private Integer productQcNum;

  @ExcelProperty(value = "抽检次品量")
  private Integer qcBadNum;

  @ExcelProperty(value = "抽检合格率")
  private java.math.BigDecimal qcRatePass;

  @ExcelProperty(value = "抽检比例")
  private java.math.BigDecimal qcRate;

  @ExcelProperty(value = "可用仓位")
  private Long whbCodeGoodId;

  @ExcelProperty(value = "次品仓位")
  private Long whbCodeBadId;
}
